CREATE EXTERNAL TABLE jms_dm.dm_lmdm_three_segment_monitoring_help_deliver_dt(
 date_time date  COMMENT '签收时间'
,sign_later_scantime timestamp COMMENT '签收时间'
,waybill_no string    COMMENT '运单号'
,input_time timestamp COMMENT '录入时间'
,order_source_code string    COMMENT '订单来源编码'
,order_source_name string    COMMENT '订单来源名称'
,real_pick_name string COMMENT '取件网点'
,real_pick_code string COMMENT '取件网点code'
,receiver_province_id bigint COMMENT '收件省份id'
,receiver_province_desc string COMMENT '收件省份'
,receiver_city_id bigint COMMENT '收件城市id'
,receiver_city_desc  string COMMENT '收件城市'
,receiver_area_id bigint COMMENT '收件区县id'
,receiver_area_desc string COMMENT '收件区县'
,receiver_detailed_address   string COMMENT '收件人详细地址'
,deliver_agent_name string COMMENT '派件网点代理区'
,deliver_agent_code string COMMENT '派件网点代理区code'
,deliver_name string COMMENT '派件网点'
,deliver_code string COMMENT '派件网点code'
,send_user_code string COMMENT '派件人员code'
,send_user string COMMENT '派件人员'
,send_three_code string COMMENT '派件人员三段码'
,help_send_user_code string COMMENT '代派件人员code'
,help_send_user string COMMENT '代派件人员'
,help_send_three_code string COMMENT '代派件人员三段码'
,first_code string COMMENT '一段码'
,second_code string COMMENT '二段码'
,third_code string COMMENT '三段码'
,sj_first_code string COMMENT '实际一段码'
,sj_second_code string COMMENT '实际二段码'
,sj_third_code string COMMENT '实际三段码'
 )
COMMENT '三段码解析监控代派明细表'
PARTITIONED BY (dt string COMMENT '签收时间')
STORED AS PARQUET
LOCATION '/dw/hive/jms_dm.db/external/dm_lmdm_three_segment_monitoring_help_deliver_dt'
TBLPROPERTIES (
          'discover.partitions' = 'false',
          'parquet.column.index.access' = 'true'
          );